package com.xymtop.sqlcater.core.sql.sqlconnecter.entity;


//所有的查询语句
public class QuerySql {

    //查询所有数据库
    public static String QUERYALLDATABASES = "show databases;";

    //查询所有的表
    public static String QUERYALLTABLES(String database){

        return "select * from information_schema.tables where table_schema='"+database+"' and table_type='base table';";
    }

    //查询所有的视图
    public  static  String QUERYALLVIEWS(String database){
        return "select * from information_schema.tables where table_schema='"+database+"' and table_type='view'";
    }

    //查询所有的字段
    public static String QUERYFIEDLS(String database,String table){

        return "select * from information_schema.columns where table_schema='"+database+"' and table_name='"+table+"';";
    }
}
